package com.future.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.future.domain.Room;
import java.util.List;

import com.future.dto.AroomNameDto;
import com.future.dto.RoomDto;
import com.future.dto.RoomForSex;
import com.future.dto.RoomForStudentsDto;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

/**
 * @Auther: 田坑坑
 * @Date: 2022/6/20 14:01
 * @Description:  我题序等你回
 */
public interface RoomMapper extends BaseMapper<Room> {



    //根据 楼栋名称  查询 宿舍名称
    List<AroomNameDto>   findRooms(@Param("storeyname") String storeyname);


    //判断宿舍性别
    List<RoomForSex>   roomFomSex(@Param("roomSex") String roomSex);


    //宿舍 连接学生 连接 用户视图
    List<RoomForStudentsDto>  roomsearchStudents(@Param("roomId") int roomId);


    //宿舍 视图
    List<RoomDto> selectRoomForStoryUserinfo(@Param("roomSex") String roomSex);


    int updateBatch(List<Room> list);

    int updateBatchSelective(List<Room> list);

    int batchInsert(@Param("list") List<Room> list);




}